#!/bin/bash

time=$(date +%Y%m%d_%H%M%S)
path='/home/data/back/'

mkdir ${path}${time} -p

path=${path}${time}/


find ${path} -mtime +30 | xargs rm -f   //删除超过30天的文件

mysqldump -uroot -p --host=localhost  jiqing | gzip > ${path}jiqing_${time}.sql.gz
